SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451971 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451971 [ RunTime:0.003827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342179,1010672,200129,776669,207215,503386,26376,554319,401934,97447,467831,720487,815348,240381,180956,579570,723836,631637,366713,271116,761800,48904,518789,997950,577042,414063,867823,794058,733148,999133,573117,704690,303351,484836,392098,908323,164586,808242,812350,518045,534855,467974,375582,957088,133857,904145,430791,60676,327918,213602,176478,377843,938890,189227,140383,849175,1076,807755,274596,513844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]