SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 629044 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 629044 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410849,170344,447444,533865,679236,47150,606913,528988,910330,235513,866746,413044,781611,472550,228803,429408,452594,64454,313789,399432,594648,1020682,754066,570309,333152,440958,155448,768738,832291,735917,573279,142005,416791,930516,131243,74176,985481,825427,272955,75049,381286,329619,98425,465197,385192,169185,770187,300771,385520,477261,64003,389520,236629,333838,145023,951243,139156,481458,613495,728032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 629044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 629044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]