SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556810 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556810 [ RunTime:0.002193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979862,979317,214160,93585,449975,702698,491349,300239,582641,509773,493322,49048,192170,930837,636279,479104,915758,180365,588505,431758,992,422942,86450,1000720,335678,930077,178276,450129,849431,463748,715214,45848,16064,73805,78207,627379,592914,322959,929472,75065,308274,701615,582494,273615,128961,585791,658056,598469,1029718,1039917,829965,226164,920132,353956,296247,588593,415414,70015,255134,103402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000713s ]