SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 213656 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 213656 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829031,943181,653103,83078,358348,202076,692890,143710,402797,590325,108532,1029114,82759,717341,30122,941290,445498,468908,529852,382299,90541,372705,135102,949783,247164,465496,210212,440674,197357,308755,346638,430600,217670,988288,831596,992615,987118,565243,845576,971839,28901,459949,313261,42160,687722,63268,288235,499968,101539,333455,908241,247964,978111,658355,270161,868801,282198,674992,427489,80230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 213656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 213656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]