SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440694 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440694 [ RunTime:0.002536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198691,777522,1029217,697570,486245,347479,391679,238945,555692,314903,186731,300066,112693,324335,71222,772627,927713,1014380,467935,594784,1042330,264549,613222,125656,128548,640990,117896,700500,56993,963030,267870,265764,350928,356239,869153,93185,68613,882750,669359,142342,491076,264355,220880,934860,107571,597354,355419,828704,79761,174916,339597,350084,128827,373842,336939,621484,151054,83780,917384,481039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]