SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001554s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034778 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034778 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189439,238187,251966,227296,575511,255980,315631,757282,755038,204978,1044483,315702,673141,43772,912879,375911,761523,833672,172630,629112,673559,837461,500661,1005340,955558,952973,779721,663583,88629,575097,886985,294092,537882,291289,696179,415169,877515,444315,103481,1045618,129131,746397,816099,545229,784237,777952,715565,159484,859908,1034311,1018748,924142,366879,529914,530763,124082,745725,996832,424403,198282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]