SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510252 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510252 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959079,180010,369223,432408,447960,920145,739100,971516,325471,892906,893968,861202,548465,149955,424018,267869,9348,615752,433092,823894,864347,929195,561598,620451,938568,773191,921865,163665,516948,626512,811255,113109,142192,524321,2388,1036712,890405,930386,1042862,603050,250758,329697,240907,504690,299578,1001562,208460,162901,182751,82163,962576,52350,740298,717660,7534,142476,54456,482940,698179,980155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000944s ]