SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419546 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419546 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218956,135718,472905,633195,107141,728616,332206,239299,529492,687732,316684,980458,505927,458405,844416,307102,639233,418548,611371,572254,950288,871024,571960,552329,1020703,972404,819067,595830,301676,953796,422626,327637,15863,601667,266548,937456,430595,969450,639698,626500,484075,396007,548170,363457,228656,791204,664271,22105,730189,407920,543175,460694,169914,165896,420549,947036,135162,468733,1040781,188718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]