SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012192 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012192 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040413,53409,443754,101583,168316,648809,921854,798038,1012602,324575,168378,69787,289570,784468,858277,142294,596680,374359,344425,754326,665833,430843,445456,994078,492297,937461,485656,895957,295693,778358,990914,79492,590215,490070,245909,835395,931479,174399,508028,273145,368523,323060,173123,575746,948802,391575,108484,461150,676047,829278,878439,187397,1026333,585217,493652,708696,281058,729942,528091,270762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000802s ]