SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423312 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423312 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771232,645960,884867,513252,549037,715478,85900,204236,505427,13841,691025,5366,1016920,694355,60880,753807,572710,551380,910717,348118,902423,503945,679939,924786,324061,991866,986472,1014120,1017226,538984,402778,678456,173071,762872,897766,787532,1021939,470595,909826,680372,100959,146038,449054,938029,451363,322273,737394,805572,989121,253850,213964,86769,278243,73673,233155,360692,896854,248904,476955,833902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]