SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467080 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467080 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145441,907784,790849,196920,92063,413136,931933,38004,452478,753362,554473,1014090,1011307,800092,971803,258686,565869,290825,256236,939904,975651,181273,487416,521037,973469,933335,395127,157337,643488,748152,572847,840599,115903,554167,441582,780173,1011187,20132,61050,694852,246138,1525,240475,5222,322897,778888,652539,38310,659832,778651,993736,215514,845421,493652,226143,320559,1045559,135547,322126,456838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]