SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597781 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597781 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219050,339411,329724,201506,510216,371349,689626,758536,929449,439183,431684,655345,428606,135967,434958,861246,599609,651380,377134,565606,807650,34421,395110,456145,809029,371805,444693,327091,718905,800184,628291,744617,260920,711191,826601,877356,367261,266528,826199,24894,112670,128871,165097,826120,201650,661247,861947,888881,513637,39657,654806,458390,443494,975048,520411,351401,928946,11349,15065,422926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]