SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550498 LIMIT 1 [ RunTime:0.000538s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550498 [ RunTime:0.002985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950714,74478,64113,965759,50951,110987,688563,974447,343575,578822,726675,547770,455250,703988,355311,601930,845472,565634,850061,873284,1011273,482934,249826,530480,862646,452965,310939,330945,371100,979348,992001,365521,50949,201138,665559,985965,588228,208524,857970,538037,759879,576205,213252,991659,18818,224178,121414,931072,554522,743871,603919,374806,148902,139609,704987,18467,144690,116449,535208,251269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]