SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517403 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517403 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52310,233839,402872,138429,566906,924178,945793,473330,209166,375756,508341,28521,832411,295326,201351,686844,564530,103680,971011,255271,270484,739584,927400,150663,333453,844522,179592,516690,728283,365760,727250,569125,972312,727614,924378,445763,301332,111780,699136,704269,684214,129811,912017,997475,719040,672986,141957,247271,916474,497508,596673,847769,493652,150056,659695,538200,275040,37535,157081,657364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]