SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498905 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498905 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145845,764214,232386,1044682,467887,936906,611688,632420,382895,778279,729944,715712,439116,161612,143772,1029109,330703,895704,569433,961997,64799,755090,445525,746051,155443,480653,69753,349708,220097,915656,413147,238706,952460,927414,381811,537048,548034,801414,598586,977059,645366,76276,905214,459175,377414,341430,478698,383445,508987,886610,738141,46651,872681,354833,251864,464524,673078,503481,361886,257722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]