SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412133 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412133 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23116,788700,741737,16143,157118,57429,45183,497768,556027,873997,597505,319364,276915,118296,485173,872538,744296,705609,723218,544749,699325,110904,841396,714715,69992,409002,325500,483167,924871,293044,525979,924887,378808,178250,20856,199859,300121,644195,827374,809614,401648,981763,752059,898694,821706,788156,642894,571901,364204,300504,989368,376874,811473,205354,429365,12676,888408,654245,416609,286179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]