SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427842 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427842 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677924,724,687855,643653,77003,629695,925293,976311,845380,987628,617059,826282,366389,124736,956703,656813,594312,542064,499720,607589,988415,702195,5535,1028578,345837,598005,466100,366228,211605,869768,746327,733684,814921,9587,394954,972498,959519,1041685,243785,565853,431955,949250,546605,411102,391423,460890,791697,308409,673721,699117,881522,383768,451737,502546,232774,259921,29750,324858,132864,974561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]