SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861496 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861496 [ RunTime:0.003041s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351586,343962,287144,645308,567127,379411,455484,790472,384117,589102,903048,624358,127274,545737,393207,784375,531965,675701,565911,995290,548386,538485,589667,612532,877986,784424,136698,496738,40140,845786,385166,234667,167214,784018,619762,582576,39105,211393,616485,788787,745945,41590,107800,405949,751586,822018,518331,653660,869553,970113,524094,389695,654530,269123,839948,328892,459013,341100,387487,61099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]