SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499028 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499028 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577281,676518,240315,462226,942700,173907,1012396,336941,878360,120123,884023,332962,44049,669436,236129,276777,400915,505392,242104,510468,974398,15977,1016798,408928,56088,661409,447094,637802,608392,804394,256027,594953,933111,472934,423644,586629,63902,564572,658012,968686,553697,802902,915300,716489,242979,54946,855067,234667,622058,750275,422644,877763,545997,268863,360391,248530,355664,966805,751985,830398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]