SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503312 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503312 [ RunTime:0.003171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663901,265971,825785,304239,11309,545345,14951,807989,377336,191626,256760,526712,453592,827050,179293,405286,543083,611287,801866,233729,476795,82027,1009217,919576,1031398,759193,786050,495410,604176,857960,605277,971574,92037,309776,507864,761918,145314,798709,751366,873640,1044702,380421,465454,300843,611584,340087,687381,210337,990636,363693,198694,828959,175007,408776,948286,790857,807661,441635,479530,234791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]