SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534312 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534312 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720443,357441,1045956,330896,309149,314995,1016370,579652,58150,622660,470731,295129,969792,48131,588788,81713,145751,44439,114176,690947,1022961,687276,980296,374331,223712,84481,739307,188715,649151,947240,676452,97649,148560,446936,159092,524141,563465,856411,996847,277823,562755,329601,74207,356676,619328,157117,828300,360847,389919,37425,784940,216334,948170,364062,154731,104934,132118,140559,386553,256965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]