SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514004 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514004 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719220,425124,286598,952285,508131,724583,467398,123819,157665,83001,510634,479051,592470,53172,781644,676725,508705,189377,1036153,342435,480947,421454,1038210,136643,14471,936479,176201,208069,595599,200963,517642,291017,895393,19221,557581,167516,1025545,388260,793280,582559,837140,796488,326913,463121,4661,995207,30606,409036,244991,334752,1012919,152382,314845,595728,837663,221346,656813,164480,63122,510094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]