SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538945 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538945 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299117,602300,444790,157358,449837,792623,580062,783135,348770,627008,1048563,506242,545074,265132,171414,631597,560136,146926,205282,313642,280816,286812,44197,134069,822124,68528,77949,357310,377754,900984,289917,331361,289737,383163,288616,327438,806299,331651,420086,280226,67020,222959,654369,923144,665348,482443,744303,814844,486640,1013803,277921,522198,146656,703377,867900,761130,653632,1887,187861,402519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]