SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404557 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404557 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469061,122551,657923,361618,702875,794972,657280,961438,470323,336361,62688,907465,934257,711417,16506,679598,96277,523411,30283,815934,619163,511876,594861,778437,343603,375037,386817,152340,772995,334800,866163,150057,932426,949482,533220,875992,25785,222615,92989,292559,747061,558928,305925,70998,692486,808537,152631,22002,483787,395996,195357,509608,870004,24127,273407,434194,716639,800124,984924,532453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404557 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404557 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]