SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534419 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534419 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332909,460512,850020,115332,374346,929202,286780,815680,624444,764005,40340,793323,305234,1019298,287114,716288,261374,106290,289716,250823,127115,758024,18095,661286,114485,319283,830240,430242,243504,305891,718382,768341,664725,485890,1004042,994575,993491,497800,517592,818742,413097,2881,1045507,88155,987023,51090,880044,68674,119499,496037,1014960,144401,568657,340983,538326,560323,264337,1022541,654254,1014263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]