SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503853 LIMIT 1 [ RunTime:0.005221s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503853 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284142,821586,42097,758643,402188,913335,907747,761881,461030,824037,430402,58014,960807,716151,69788,78403,673636,323567,339193,355508,67817,144148,842266,257507,509881,113830,802594,785717,633757,206605,631550,738738,985252,909173,701046,759105,1015433,912798,85412,713205,943911,538269,736711,371837,417791,396810,173306,1002245,848156,398302,967473,1005815,847521,796984,124349,576322,537668,607189,151824,315275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]