SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109227 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109227 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145204,155669,999341,762126,636221,327840,332485,725870,968788,845842,313017,216859,337987,401092,369129,535164,126349,884899,549174,725302,147121,530911,801995,635942,34646,315868,882856,744331,252685,436650,29066,907070,449756,471026,674029,196213,898289,803427,401205,281935,371516,48139,621900,891991,908782,340514,133326,1021379,258954,724559,279481,906547,310566,603237,115622,405216,15022,445505,1044211,656843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]