SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026058 LIMIT 1 [ RunTime:0.000757s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026058 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139255,323092,83108,845028,678447,946589,127986,936297,51186,211416,448542,200851,864431,429310,112688,98036,153719,941256,460458,1012813,791997,657489,434655,274642,438048,658866,718904,146010,837608,982977,743184,392095,1044691,696903,747963,293439,260480,873836,497393,129684,936319,785526,130587,785930,285613,618424,109962,344201,42434,791305,580979,450651,623404,185571,608635,31990,233896,96613,120284,349187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]