SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023831 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023831 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401555,413197,103859,1014877,179434,59120,954147,459847,297922,460786,135705,608153,762923,881523,236013,132594,74458,460618,822514,536333,902178,893881,664937,688774,333223,279244,849013,745040,118356,439363,612653,243530,76423,614528,31936,683235,236626,506912,9612,880476,523861,971565,412417,44915,444145,850795,266264,443321,599505,630725,658310,794472,217717,908285,193220,237153,24762,485111,142625,817148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]