SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001761s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201033 LIMIT 1 [ RunTime:0.000760s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201033 [ RunTime:0.002821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63391,707841,178897,216171,1048059,215619,827620,378035,1025866,497513,150930,750359,1023776,21125,518154,393665,888652,945296,76280,530614,55920,756355,547765,740511,489006,274349,212145,108269,709845,925038,212875,486249,900634,234023,1010285,672997,993162,634964,951650,642208,899067,218651,771503,695779,251654,125007,182244,318229,606204,1272,959763,120566,718538,638174,727680,808918,208362,933146,357889,655764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000856s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005402s ]