SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001833s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405016 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405016 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283093,104914,871937,511237,362912,862101,422705,386366,988123,935699,745542,344856,713068,57476,421983,319320,691070,783503,949915,590070,508243,512058,220657,626429,436555,37244,272025,856301,948631,434003,88760,865639,997854,208687,859659,142718,592356,273477,750801,257365,963592,810292,447750,790938,840050,660109,866571,118025,1041700,673962,75492,882625,693540,212622,477501,510869,789321,275711,453834,719222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]