SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502160 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502160 [ RunTime:0.001457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212488,973199,799255,330145,839366,648122,761447,507024,834585,377173,913509,587352,976757,1000230,219239,285251,863338,239024,702916,644119,442465,403983,249983,547649,835930,128356,1030887,907031,824206,1022862,831032,447991,83289,20793,458689,1002707,282453,410007,987517,264263,646344,937,391240,707280,1027953,519879,126154,935875,44703,750393,102686,932500,94738,1025523,576409,960302,790894,368108,467247,713121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]