SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045284 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045284 [ RunTime:0.002788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385012,796719,613498,40644,905233,307724,667177,478646,838847,634071,305892,754814,99156,209800,253149,127859,821353,185445,551909,161484,415016,798715,514676,384022,310149,616387,137542,583456,683831,488118,939723,878644,1002381,337507,927218,825474,373163,212710,1029082,69889,597286,316296,363165,972266,972574,528114,1124,909282,836285,475198,956584,435574,790328,639466,916189,718314,572484,611316,351968,522311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]