SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556424 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556424 [ RunTime:0.002088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647945,203871,176722,870082,82158,732735,154217,840016,425801,353883,928778,856574,396526,13967,580849,588800,377984,565247,394260,698835,112472,525969,552360,89244,905358,5196,1042940,609771,911568,406372,323482,940753,526241,375706,653782,988702,343305,237737,555829,255499,168124,967368,95599,423349,876723,483392,891080,69905,47010,1017951,113010,1016504,491512,695348,417880,690628,660795,438720,744193,610863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]