SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565275 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565275 [ RunTime:0.002853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534049,607399,174503,796393,864424,222949,166875,226053,896650,527093,203280,227438,985801,105137,936593,446152,316301,297810,113297,615703,744047,56730,998720,268200,629392,904720,330145,207830,88816,890342,247677,365658,670986,131842,997212,806814,209266,857521,351439,17640,1005213,636617,674228,259853,723810,335440,724857,490227,945065,974847,283035,1008070,233274,463403,501303,1011528,43891,90476,299299,911513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565275 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565275 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]