SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332213 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332213 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037918,405849,19870,944034,436386,506162,464116,962926,44259,53012,191129,877957,680761,970409,12913,383056,334016,538228,165419,802869,614023,321167,951413,17637,735243,470436,427378,137822,766532,656581,447805,755848,102599,408463,920611,1038279,789438,783951,840652,110047,627834,929842,959543,414300,83348,729514,810129,205269,452193,146044,580316,614302,131375,949894,401990,662505,863739,905215,470387,767824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]