SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001585s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98615 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98615 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228872,108266,336888,720670,1014869,720025,1035243,710284,624889,179437,505368,1034109,580721,207208,287103,914543,56024,65772,75928,818914,534958,462796,338262,870645,682309,786681,422183,391882,754840,425570,990354,920383,1033912,1018294,655990,911010,1003139,376365,577376,619077,953424,349320,428812,182429,989976,931158,434976,1025860,981177,592992,140004,572849,782637,75888,277236,470170,293334,418152,739609,631123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]