SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509306 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509306 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356818,845261,409126,936734,681827,845280,196709,54288,937648,752438,499750,186890,233703,83563,7988,54098,981241,54925,391056,635356,645588,500764,584177,122110,916562,460536,315697,371366,500454,302801,283449,308539,1025851,151269,861853,896089,307618,220935,382666,68907,998360,275460,248067,540582,382723,374393,261209,1036122,244524,178837,143310,781736,693068,44420,111389,805447,503465,757737,689973,574229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]