SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506394 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506394 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403624,994387,521350,78181,120674,609416,637167,964260,958121,560064,909751,551996,179489,196935,281235,1017766,752316,8820,72968,163167,881144,978399,905669,824127,982427,622315,716389,1026068,213116,450988,12933,621529,30431,561176,543909,409063,106601,480901,825680,827641,482119,617247,924866,359014,17381,801917,286784,228779,609100,131087,779172,29524,2109,708497,745039,553667,472227,248068,203477,65782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]