SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519036 LIMIT 1 [ RunTime:0.002074s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519036 [ RunTime:0.003682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78856,797529,947821,794253,81274,632030,194133,672812,687445,395061,561094,779999,115443,437201,200879,895745,665988,930227,104799,636904,771366,797329,1020243,358054,13646,293015,566752,1046075,22146,845071,738090,753106,744749,905196,934314,830085,817460,661975,407261,921581,393817,402884,641287,253101,239554,1012189,79194,279913,382269,233510,506362,330848,658649,862621,79039,456252,179632,104240,72360,516591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.029223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003094s ]