SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319851 LIMIT 1 [ RunTime:0.000663s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319851 [ RunTime:0.001215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827463,132436,307519,408076,681675,386228,120381,696096,846808,114279,1024142,212114,21370,536606,973472,109123,530462,927191,112544,181954,758308,980433,39396,33350,162100,205523,3258,893320,256078,531735,900908,287524,874276,741446,534514,279064,487752,734090,995229,815675,517372,269323,760307,1012732,1017060,843960,442812,178024,709733,38089,599153,612353,569716,4594,64128,47399,232537,326220,211772,864489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003809s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]