SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001675s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028633 LIMIT 1 [ RunTime:0.001909s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028633 [ RunTime:0.005612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935877,710208,272135,858723,666796,789580,367213,697522,32201,748556,1024164,259097,237026,220384,7457,888391,421729,412962,133758,157520,308678,409520,52815,261743,438344,201550,274970,950716,60244,494028,740942,692118,934723,140844,528051,553699,848016,935585,746861,345080,586173,850313,911929,910829,756926,1036448,192070,918072,525752,747462,203935,369148,182571,980602,920384,561890,99698,1040815,383622,329807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002420s ]