SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148111 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148111 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427160,550580,350650,565340,693019,641481,115913,615243,647480,348825,270859,617186,1005685,837062,41483,803675,1033075,578546,741129,1010827,508136,746865,869011,997269,140448,758714,1017057,441136,62207,500039,200680,818739,352257,618664,208706,681379,892383,393390,99646,1013656,743462,651067,725264,464446,74696,854490,329265,455702,131599,764823,59291,830207,287088,78091,1003736,1000426,856642,711525,192436,521617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]