SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014120 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014120 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624482,248560,722665,54293,914609,144041,192060,274550,710938,685854,374903,421472,474803,718771,265478,211849,54979,970243,187515,243777,282504,270276,825440,870889,772941,562286,272419,154232,121279,125347,287886,450015,899971,807619,233226,979055,734067,43240,242841,622226,50649,161180,605675,854301,145625,297185,880579,1000777,542938,39732,902381,865151,736514,598091,18172,947031,916608,889297,268751,682387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002505s ]