SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507017 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507017 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908529,102352,135812,679850,933440,225776,244038,51618,230087,288343,67479,592528,901204,984039,769084,144245,453569,343161,400972,607990,935736,949409,923051,722543,971602,350496,256760,250266,85577,329368,20364,210302,390014,50808,155329,571567,233719,719202,776663,748009,211265,769497,831065,882278,549597,159260,461988,862243,532558,454683,766329,780345,130143,1005931,74491,228774,397620,711815,974239,881247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]