SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402114 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402114 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524430,788023,957640,645205,311773,510352,853220,934429,701828,974426,88056,580274,16566,133382,428570,213091,273109,212993,763535,746018,315148,685292,505208,383727,464956,493975,1025916,181838,690260,1022216,620744,901999,784132,573606,36682,614568,857322,680066,853833,468309,351740,66514,300294,770954,306636,1015947,517434,40196,948006,892289,107788,400153,1032624,390218,635633,41791,968836,240263,866467,836418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001212s ]