SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399518 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399518 [ RunTime:0.002842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621500,531471,143523,958473,886236,575174,451612,835866,67604,786225,34161,426624,819209,579709,825385,124875,355893,747371,592059,297026,40129,912962,254641,759652,920496,543686,723104,696575,385419,842623,945948,282586,865078,179634,509691,194421,952738,255830,959281,43156,301111,684369,194459,329028,111200,383007,20601,776650,285598,898254,520270,949472,405414,332921,405562,580664,1041147,814575,401646,759513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]