SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53480 LIMIT 1 [ RunTime:0.001210s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53480 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341073,39508,131685,463775,143654,671113,631799,366783,510069,334080,786669,815976,847741,242281,684266,593262,458106,954899,368377,924236,63388,290885,328202,79407,453069,957117,257917,704343,984660,1040524,407658,988666,468510,77496,704137,850771,216656,790315,743713,645830,774903,546142,1022975,345958,297897,764120,785634,199765,946912,610581,699769,969841,875080,845315,153771,279647,564130,193632,158488,943476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000835s ]