SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535802 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535802 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503911,971061,279256,628125,248467,153059,128232,686928,978874,171303,1006384,207952,295750,705089,364204,499544,85,920185,546294,298831,110674,244870,551785,649375,171973,354863,773511,832520,2841,413534,265664,420995,1042405,574269,3576,757317,911608,963653,803053,621901,832772,849614,292897,835777,455654,688310,760067,350583,635540,407484,969251,287395,889045,771559,66505,798358,892894,659785,439339,551888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]