SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446023 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446023 [ RunTime:0.003182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974276,403572,899227,487274,197727,59988,613207,822546,456202,50449,754804,599738,43508,457812,186191,855987,497085,180143,411491,329894,784712,902323,13157,957105,204472,989798,917042,796319,362563,121683,795656,152851,123629,710097,582717,58562,936411,460169,1003431,867676,295432,226423,223182,784588,158301,103386,738132,102436,192083,782626,26213,306517,478742,162248,747517,145868,207630,188763,878906,864984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]