SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459906 LIMIT 1 [ RunTime:0.003342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459906 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120586,1028753,59005,798222,147794,68735,251541,1020874,12600,501933,88957,756417,551217,305583,472979,751394,263341,945177,390257,964514,610303,378921,465529,161169,621019,900333,823145,806300,208862,661053,430705,1023223,268182,385979,412310,354506,382550,361383,1012422,925586,920666,889782,411412,439542,481985,597033,555657,383654,886478,981362,71610,724999,102351,69103,814639,771103,1039299,422109,595113,611501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]