SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601015 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601015 [ RunTime:0.002473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504092,595281,231029,189445,586606,971360,1008877,65668,854156,716484,20821,811481,24840,738512,361391,937590,351670,925221,18193,749253,232929,852932,239896,588703,402809,943447,980986,540631,213640,1030011,690955,314787,716091,28058,118538,503513,257705,698526,338291,225630,1014417,467350,808021,117280,396376,367875,210099,549900,204272,376021,938323,769116,740208,367116,916104,583149,524528,639919,833396,829064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001084s ]