SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981027 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981027 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522983,633211,153340,389193,396705,903520,645180,88978,350254,349902,468560,51341,600412,346007,387506,696222,459952,978005,466379,549038,310282,811007,720053,209363,195746,982065,714994,657313,829187,178210,671968,1022166,946829,222250,611226,27157,444713,177283,961333,835239,136608,828281,369343,669565,936657,485902,948327,949457,231688,20548,880261,460296,180422,6388,56964,980343,349403,921277,1048849,193839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002481s ]