SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591229 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591229 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815879,1044832,256183,906970,103802,883748,150115,383713,469493,684187,338630,174906,221885,332459,114319,494753,1020813,965356,932452,147913,506972,56714,189008,45694,959183,679689,304430,363973,575269,349691,687846,448440,291816,658309,433695,119396,617970,372556,502057,871932,409624,719417,5323,136474,865734,503577,473443,47738,445626,393721,2992,623999,503316,430591,805566,826239,501510,428733,240622,795411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591229 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591229 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000977s ]