SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598503 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598503 [ RunTime:0.002025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892942,528873,18632,674957,79591,211903,1037753,859714,798019,539640,457010,779499,577105,182155,353608,756744,281128,596321,315359,758362,857480,537666,242188,210771,1041406,733753,695733,1025828,379948,136165,836398,619849,453501,244429,935621,1038603,534899,1022541,813831,87391,517490,446722,177400,830415,441777,913822,778411,583714,18365,1008323,14551,135194,681784,389588,897656,1001153,788532,1013043,714575,521640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]