SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 116343 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 116343 [ RunTime:0.002546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031364,614103,406539,18661,587470,872762,699747,1000303,487159,580780,1032681,611216,356527,359814,544170,780745,1021844,1025056,408471,635534,720796,921462,687220,767669,374521,1034137,332249,93932,955267,311844,150296,201836,828001,100247,508680,104347,746133,411113,268525,936566,571438,135775,577735,215275,304808,838010,312909,133065,411924,401829,508226,832889,967286,567738,50460,443640,216676,673836,803992,918686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 116343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 116343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]