SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803514 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803514 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044108,630771,126755,98964,791152,946855,227134,110332,370675,901232,58164,638179,570886,97559,600025,447072,393770,85354,580569,936429,981319,1043473,91794,488521,735161,726935,354971,624788,366109,591291,338593,1006512,1044294,297704,981236,74033,996221,798865,915277,65311,301242,343049,616403,103528,128021,892286,644868,936184,415994,892484,505071,198786,69013,36006,786918,1028203,209058,300179,948063,243924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001941s ]