SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343894 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343894 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342671,878350,69069,1040149,348251,664110,181271,794716,671518,656333,815944,1006500,787179,950273,450398,221546,820868,886020,487097,488399,1015426,508594,856359,763990,951336,867543,283688,3581,565863,853272,790051,180817,700126,768003,1025704,125957,1020938,725551,172940,202143,465414,559536,365010,466822,893969,577401,220048,687352,11859,594801,326307,987270,391298,363693,681335,460124,621707,612933,224209,516768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]