SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419488 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419488 [ RunTime:0.002801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723807,277735,770640,234674,539056,298814,943785,717485,442430,809514,989383,454891,250751,335482,863739,360829,694779,217362,502852,920801,66434,137421,640889,390752,74497,923867,467102,786130,492340,875871,335436,90213,844682,194147,898122,961591,493713,749453,409674,245929,331164,508120,712361,726459,552207,422607,189864,207125,241969,787505,371594,663553,185176,567394,430005,541832,1001365,211750,293331,475904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419488 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419488 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002939s ]