SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326865 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326865 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488710,523947,830744,948897,371022,412150,976438,648599,5903,124478,580672,880181,455471,385037,489264,580715,21448,599869,519314,828721,840256,494446,572360,382577,295009,515616,897513,991307,750633,377672,570096,100114,516626,9667,102384,97337,92092,602147,480763,487241,188848,476432,676912,637052,1036202,858706,232504,1024755,1000544,375377,33365,190758,557924,379492,80474,253955,79081,209393,56625,862263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326865 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326865 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]