SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393964 LIMIT 1 [ RunTime:0.000620s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393964 [ RunTime:0.004697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985571,179110,981008,600117,440057,838830,189716,842520,555381,383806,509663,758567,149519,117839,499718,434344,102023,494015,163645,70377,775152,238002,962055,992536,916390,719749,497346,772409,128070,732673,187593,916042,282283,894221,334381,146649,944887,770306,667566,754165,562988,2320,992075,690539,329252,412572,963220,501271,310234,9305,70796,755989,776010,167516,619008,481173,755631,45283,359282,488475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]