SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020343 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020343 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752879,254147,53310,56933,837647,186311,327268,857752,189838,110825,849311,562080,983458,999782,228819,566630,719897,850788,929118,107089,1421,410496,75978,812622,153971,207565,800104,112009,576430,482177,356280,1010190,511441,371502,764624,382923,966245,382520,192464,605773,699825,341278,914544,618145,49224,152404,908349,357750,794639,499352,595855,949090,272081,640206,760109,554447,252527,629017,186640,685917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005952s ]